package com.pj.lib.aura.storage;

import android.net.Uri;
import android.provider.BaseColumns;

public final class AuraDB {

	public static final String AUTHORITY = "com.pj.lib.aura.storage.aura";
	
	private AuraDB() {};
	
	public static final class UserLocationsColumns implements BaseColumns {
		private UserLocationsColumns() {};
		
		/**
         * The content:// style URL for this table
         */
        public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY + "/userLocations");

        /**
         * The MIME type of {@link #CONTENT_URI} providing a directory of locations.
         */
        public static final String CONTENT_TYPE = "vnd.android.cursor.dir/vnd.pj.userLocation";

        /**
         * The MIME type of a {@link #CONTENT_URI} sub-directory of a single location.
         */
        public static final String CONTENT_ITEM_TYPE = "vnd.android.cursor.item/vnd.pj.userLocation";

        /**
         * The default sort order for this table
         */
        public static final String DEFAULT_SORT_ORDER = "modified DESC";
        
        
        /**
         * Id of user (this is id of user in server db)
         * <P>Type: TINYINT</P> 
         */
        public static final String USER_ID = "USER_ID";
        /**
         * Nick name of user
         * <P>Type: VARCHAR(50)</P> 
         */
        public static final String NICK_NAME = "NICK_NAME";
        /**
         * Longitude coordinate
         * <P>Type: NUMERIC(10,7)</P> 
         */
        public static final String LONGITUDE = "LONGITUDE";
        /**
         * Latitude coordinate
         * <P>Type: NUMERIC(10,7)</P> 
         */
        public static final String LATITUDE = "LATITUDE";
        /**
         * Accuracy of this location
         * <P>Type: NUMERIC(3)</P> 
         */
        public static final String ACCURACY = "ACCURACY";
        /**
         * Time of this location
         * <P>Type: DATETIME</P> 
         */
        public static final String TIME = "TIME";
	}
}
